﻿CREATE TABLE [dbo].[Location] (
    [LocationID]             INT             IDENTITY (1, 1) NOT NULL,
    [entID]                  SMALLINT        NOT NULL,
    [locationName]           NVARCHAR (50)   NULL,
    [address1]               NVARCHAR (300)  NULL,
    [address2]               NVARCHAR (300)  NULL,
    [city]                   NVARCHAR (100)  NULL,
    [zip]                    NVARCHAR (10)   NULL,
    [ManagerUserID]          INT             NULL,
    [locationTypeID]         SMALLINT        NOT NULL,
    [locationParentID]       INT             NULL,
    [locationLat]            NUMERIC (10, 6) NULL,
    [locationLong]           NUMERIC (10, 6) NULL,
    [locationStateLicenseID] NVARCHAR (50)   NULL
);



